{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 推荐规则\n",
    "-v1.2 李昱辰\n",
    "\n",
    "#### 规则一：每个用户的好友(或粉丝)中与该用户具有相同兴趣的人占多数  \n",
    "#### 规则二：与用户越相似的好友或粉丝，其标签越可能是用户的标签  \n",
    "#### 规则三：用户与某好友互动频率越高，用户与该好友的兴趣相似度越大（包括评论、动态、聊天）  \n",
    "\n",
    "### 一. 用户标签规则\n",
    "因为APP注册过程并没有强制性的添加兴趣爱好，所以用户一些相对标签无法获得，只能获得用户地址，学校，专业，毕业时间等。  \n",
    "这个时候需要给用户一些默认的标签，按照用户所在学校的人群大类兴趣，从学校的用户的已有数据，进行推导，把大类标签作为用户的默认标签。\n",
    "\n",
    "1.学校标签  \n",
    "通过学校的共同性进行推荐，清华的学生更多地推荐清华的学生  \n",
    "\n",
    "2.专业标签  \n",
    "通过专业的共同性进行推荐，但是因为有很多交叉学科（比如UI设计就是设计和心理学、计算机的交叉学科，这样可以给用户打上不同的用户标签，推荐多个设计、心理学、计算机的个集或者交集的用户）、相同大类用户（比如文科类用户推荐文科用户、理科类用户推荐理科用户、工科推荐工科或者理科用户） \n",
    "\n",
    "3.学院标签\n",
    "通过学院的共同性进行推荐，经济学院的学生更容易和经济学院的学生形成交流\n",
    "\n",
    "3.年限推荐  \n",
    "大学四年时间内，所接触到的各个年级学生，更容易成为密集交流者  \n",
    "  \n",
    "4.兴趣推荐  \n",
    "1)用户设定兴趣的推荐  \n",
    "  通过用户自己设定的兴趣进行推荐，但是因为用户的“设定行为”具有不确定性，所以对于用户的准确的兴趣有一定的标准差。  \n",
    "2)用户行为兴趣的推荐  \n",
    "  ①用户好友的兴趣标签：取出现最多的几个标签作为用户隐性标签。  \n",
    "  ②用户参与活动的兴趣标签：因为活动没有设定标签，可以通过参与用户中出现最多的几个标签，作为活动的标签，这样也可返回为用户兴趣标签。\n",
    "\n",
    "### 二.用户价值\n",
    "用户价值暂时定为用户使用频率（单日内打开次数）、用户使用时长（单日内所有时长）、用户影响指数（动态被参与次数，如转发、评论、点赞等）  \n",
    "\n",
    "#### 1.使用频率与用户使用时长  \n",
    "用以衡定用户活跃度，如果长时间没有使用，那么用户对于平台的价值会下降。  \n",
    "\n",
    "#### 2.用户影响指数  \n",
    "##### 规则一：影响力越高的用户回复的动态的影响力越高，从而使该动态主人的影响力变高。  \n",
    "  \n",
    "##### 规则二：影响力越高的用户转发的动态的影响力越高，从而使该动态原创作者的影响力变高。  \n",
    "  \n",
    "##### 规则三：影响力越高的用户倾向于在其动态中@影响力高或者的用户。  \n",
    "  \n",
    "PageRank算法：  \n",
    "1.赋予所有用户相同的权重。  \n",
    "2.将每个用户的影响力权重按照其关注的人数等量分配  \n",
    "3.对每个用户来说，其影响力等于其粉丝分配给他的权重之和  \n",
    "4.第2步和第3步迭代，直到权重不再发生大的变化为止  \n",
    "\n",
    "运用pagerank算法，可以计算出不同的用户，不同的影响力权重。\n",
    "但是这个权重有很大的不稳定性，如果有人因为一些原因，关注的人和好友突涨，那么整体的影响力会上升特别快。\n",
    "用户的影响力除了他的动态关系之外，还与他的个人属性有很大的关系，比如动态的质量。动态的质量可以采用其被转发的数目、被回复的数目、被点赞的数目来得到。\n",
    "\n",
    "### 三.用户相似度\n",
    "运用余弦相似度来衡定用户的相似性，加入权重因素，让衡定结果更准确。  \n",
    "\n",
    "##### 1.余弦相似度\n",
    "余弦夹角公式： \n",
    "$$ \\cos\\theta = \\frac{\\alpha*\\beta}{|\\alpha|·|\\beta|} $$  \n",
    "\n",
    "公式变形后：\n",
    "$$ \\cos\\theta = \\frac{\\alpha*\\beta}{\\sqrt{\\alpha^2}·\\sqrt{\\beta^2}} $$\n",
    "\n",
    "运用：   \n",
    "  \n",
    " 用户  |  学校  |  专业  | 兴趣大类 | 兴趣小类  \n",
    "user1 | 锦城大学| 经济学 |   体育   |  足球  \n",
    "user2 | 锦城大学| 保险学 |   体育   |  足球  \n",
    "\n",
    "转换为用户矩阵：  \n",
    " 用户  |  锦城大学  |  经济学  |  保险学  |  体育  |  足球  \n",
    "user1 |      1    |    1    |    0    |   1   |    1  \n",
    "user2 |      1    |    0    |    1    |   1   |    1  \n",
    "\n",
    "则两个用户的相似度为：\n",
    "$$\\because \\cos\\theta = \\frac{1\\times1+1\\times0+0\\times1+1\\times1+1\\times1}{\\sqrt{1^2+1^2+0^2+1^2+1^2}\\times\\sqrt{1^2+0^2+1^2+1^2+1^2}} $$  \n",
    "\n",
    "$$\\therefore \\cos\\theta = \\frac{3}{4} = 0.75$$  \n",
    "\n",
    "权重算法：对于大类加上权重，比如锦城大学、比如体育  \n",
    " 用户  |  锦城大学  |  经济学  |  保险学  |  体育  |  足球  \n",
    "user1 |      2    |    1    |    0    |   2   |    1  \n",
    "user2 |      2    |    0    |    1    |   2   |    1  \n",
    "\n",
    "$$\\because \\cos\\theta = \\frac{2\\times2+1\\times0+0\\times1+2\\times2+1\\times1}{\\sqrt{2^2+1^2+0^2+2^2+1^2}\\times\\sqrt{2^2+0^2+1^2+2^2+1^2}} $$  \n",
    "\n",
    "$$\\therefore \\cos\\theta = \\frac{9}{10} = 0.9$$  \n",
    "  \n",
    "加上权重过后，相同的会表现出更好的相同性，但是不同的，就会更不同。  \n",
    "##### 2.余弦相似度变形  \n",
    "对于公式再理解，可以看出其实就是相同的特征在所有的特征中的占比。  \n",
    "\n",
    "$$\\because \\cos\\theta = \\frac{相同的特征}{所有特征} $$  \n",
    "$$\\therefore \\cos\\theta = \\frac{user1_s\\bigcap user2_s}{user1_s\\bigcup user2_s}$$\n",
    "\n",
    "### 四.用户联系系数  \n",
    "##### 1.用户互动系数  \n",
    "用户互动系数为不同用户之间的交流系数，包括用户的所有互动（交流、评论、点赞、转发、参与）  \n",
    "\n",
    "$$ \n",
    "设 交流为X_1、评论为X_2、转发为X_3、点赞为X_4、参与X_5,\\therefore \\lambda_1>\\lambda_2>\\lambda_3>\\lambda_4>\\lambda_5\n",
    "$$  \n",
    "$$\n",
    "用户互动系数 = \\log\\sum^n(\\lambda_1 X_1 + \\lambda_2 X_2+\\lambda_3 X_3+\\lambda_4 X_4+\\lambda_5 X_5)\n",
    "$$  \n",
    "\n",
    "##### 2.用户联系系数 （用户互动相似系数）\n",
    "用户A有两个互动系数较高用户B与用户C，用户B和用户A的互动系数等于30，用户C与用户A的互动系数等于31，则用户B到用户A的互动相似系数为30/31=0.96   \n",
    "$$  \n",
    "设 A\\to B = 30,C\\to B =31\n",
    "$$  \n",
    "$$\n",
    "用户联系系数 = \\frac{min(A\\to B,C\\to B)}{max(A\\to B,C\\to B)}\n",
    "$$   \n",
    "\n",
    "这样推荐出来的用户，更容易三人为团，形成一个社交圈  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data = pd.read_csv('../data/user_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data = user_data.drop('Unnamed: 0',axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 创建模拟用户\n",
    "用以寻找相近的用户"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "userA = pd.Series([\n",
    "    101,\n",
    "    '四川',\n",
    "    '成都市',\n",
    "    '西华大学',\n",
    "    '经济学院',\n",
    "    '文学',\n",
    "    '经济学',\n",
    "    '影视',\n",
    "    '美丽人生',\n",
    "    '2011',\n",
    "    '技能',\n",
    "    '编程',\n",
    "    '名人',\n",
    "    '搞笑漫画日和',\n",
    "    '宋冬野',\n",
    "    '搞笑漫画日和',\n",
    "    '妖精的尾巴',\n",
    "    '七龙珠',\n",
    "    '搞笑漫画日和'\n",
    "])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### $$ 推荐系数 = \\log(\\lambda_1 * 互动系数 + \\lambda_2 * 用户价值 + \\lambda_3 * 用户相似度) $$"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "构建虚拟用户互动系数和用户价值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['similarity'] = ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "score_list = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "userA_set = set(userA)\n",
    "userB_set = set(userA)\n",
    "for i in range(0,len(user_data)):\n",
    "    userB_set = set(user_data.loc[i])\n",
    "    score = len(userA_set&userB_set)/(np.sqrt(len(userA_set))*np.sqrt(len(userB_set)))\n",
    "    score_list.append(score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['similarity'] = score_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['value'] = ''\n",
    "user_data['value'] = user_data['value'].apply(lambda x : np.random.choice(range(1,10)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['connect'] = ''\n",
    "user_data['connect'] = user_data['connect'].apply(lambda x : np.random.choice(range(1,10)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for i in range(0,len(user_data)):\n",
    "    #核心算法，权重可修改进行推荐\n",
    "    user_data['score'][i] = np.log10(0.2*user_data['connect'][i]+0.2*user_data['value'][i]+12*user_data['similarity'][i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>region_parent</th>\n",
       "      <th>region_detail</th>\n",
       "      <th>school_parent</th>\n",
       "      <th>school_detail</th>\n",
       "      <th>major_parent</th>\n",
       "      <th>major_detail</th>\n",
       "      <th>interest_parent</th>\n",
       "      <th>interest_detail</th>\n",
       "      <th>interest_parent1</th>\n",
       "      <th>...</th>\n",
       "      <th>interest_detail2</th>\n",
       "      <th>year</th>\n",
       "      <th>interest_detail3</th>\n",
       "      <th>interest_detail4</th>\n",
       "      <th>interest_detail5</th>\n",
       "      <th>interest_detail6</th>\n",
       "      <th>similarity</th>\n",
       "      <th>value</th>\n",
       "      <th>connect</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>10154</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>2008</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>0.596559</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0.911621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>10213</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>技能</td>\n",
       "      <td>编程</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>2004</td>\n",
       "      <td>死神</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>0.370479</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>0.894635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>10036</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>影视</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>编程</td>\n",
       "      <td>2011</td>\n",
       "      <td>绘画</td>\n",
       "      <td>编程</td>\n",
       "      <td>绘画</td>\n",
       "      <td>文案</td>\n",
       "      <td>0.325396</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>0.851549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>10674</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>迈克尔·杰克逊</td>\n",
       "      <td>2010</td>\n",
       "      <td>林允</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>杨幂</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>0.285831</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.846954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>10386</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>建筑学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑学</td>\n",
       "      <td>名人</td>\n",
       "      <td>迈克尔·杰克逊</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>2003</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.841265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>10713</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>国际经济与贸易</td>\n",
       "      <td>综艺</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>摄影</td>\n",
       "      <td>2008</td>\n",
       "      <td>文案</td>\n",
       "      <td>文案</td>\n",
       "      <td>料理</td>\n",
       "      <td>编程</td>\n",
       "      <td>0.370479</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>0.835421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>10785</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>名人</td>\n",
       "      <td>GALA</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>2000</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>绘画</td>\n",
       "      <td>编程</td>\n",
       "      <td>书法</td>\n",
       "      <td>0.370479</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>0.835421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>10655</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>影视</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>策划</td>\n",
       "      <td>2008</td>\n",
       "      <td>写作</td>\n",
       "      <td>写作</td>\n",
       "      <td>设计</td>\n",
       "      <td>文案</td>\n",
       "      <td>0.317554</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0.833188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>10843</td>\n",
       "      <td>四川</td>\n",
       "      <td>资阳市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>影视</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>2015</td>\n",
       "      <td>编程</td>\n",
       "      <td>设计</td>\n",
       "      <td>设计</td>\n",
       "      <td>绘画</td>\n",
       "      <td>0.271163</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>0.823080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>10829</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>文案</td>\n",
       "      <td>2001</td>\n",
       "      <td>摄影</td>\n",
       "      <td>花艺</td>\n",
       "      <td>绘画</td>\n",
       "      <td>书法</td>\n",
       "      <td>0.370479</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>0.822544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>10647</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>名人</td>\n",
       "      <td>迈克尔·杰克逊</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>2004</td>\n",
       "      <td>死神</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>死神</td>\n",
       "      <td>0.317554</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>0.820244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>10614</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>2007</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.815477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>10744</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>春娇与志明</td>\n",
       "      <td>2016</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>漫威</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.258544</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>0.813082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>10985</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2010</td>\n",
       "      <td>编程</td>\n",
       "      <td>摄影</td>\n",
       "      <td>策划</td>\n",
       "      <td>文案</td>\n",
       "      <td>0.423405</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.811633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>10274</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>2006</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>0.271163</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0.809826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>10460</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>技能</td>\n",
       "      <td>编程</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>2012</td>\n",
       "      <td>GALA</td>\n",
       "      <td>迈克尔·杰克逊</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>0.352941</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>0.808568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>10974</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>终结者</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>2006</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>0.317554</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>0.806902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>10346</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>投资学</td>\n",
       "      <td>影视</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2005</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>0.317554</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>0.806902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>10665</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>汉语言文学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>2004</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>0.264628</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.804517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td>10576</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>2006</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>0.264628</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>0.804517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>10895</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>2001</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>0.801986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>10445</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>绘画</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>2001</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>漫威</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>0.310253</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>0.800925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>789</th>\n",
       "      <td>10789</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>电气学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>电气工程</td>\n",
       "      <td>美食</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>2014</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>0.258544</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.799515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>10224</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>艺术学院</td>\n",
       "      <td>艺术学</td>\n",
       "      <td>播音主持</td>\n",
       "      <td>名人</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>写作</td>\n",
       "      <td>2014</td>\n",
       "      <td>料理</td>\n",
       "      <td>文案</td>\n",
       "      <td>书法</td>\n",
       "      <td>编程</td>\n",
       "      <td>0.258544</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0.799515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>10207</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2002</td>\n",
       "      <td>策划</td>\n",
       "      <td>写作</td>\n",
       "      <td>文案</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>0.258544</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>0.799515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>10545</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>国际经济与贸易</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>2004</td>\n",
       "      <td>设计</td>\n",
       "      <td>料理</td>\n",
       "      <td>绘画</td>\n",
       "      <td>书法</td>\n",
       "      <td>0.258544</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.799515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>10700</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>林允</td>\n",
       "      <td>2005</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>0.271163</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0.796155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>10992</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2017</td>\n",
       "      <td>编程</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>料理</td>\n",
       "      <td>料理</td>\n",
       "      <td>0.370479</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>0.795585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>10958</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2012</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>料理</td>\n",
       "      <td>写作</td>\n",
       "      <td>0.211702</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.788199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>10117</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>测控技术与仪器</td>\n",
       "      <td>综艺</td>\n",
       "      <td>创造101</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>设计</td>\n",
       "      <td>2002</td>\n",
       "      <td>编程</td>\n",
       "      <td>设计</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>花艺</td>\n",
       "      <td>0.211702</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.788199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>939</th>\n",
       "      <td>10939</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>2006</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0.308587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>10212</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>死神</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>2004</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0.308587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>10542</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械电子工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>死神</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>2002</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0.308587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10020</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>美食</td>\n",
       "      <td>火锅</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>档案</td>\n",
       "      <td>2003</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>0.051709</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.305460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>551</th>\n",
       "      <td>10551</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>综艺</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>2014</td>\n",
       "      <td>火锅</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>0.301030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>10517</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>综艺</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2004</td>\n",
       "      <td>料理</td>\n",
       "      <td>摄影</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>料理</td>\n",
       "      <td>0.111283</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.286770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>10693</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>档案</td>\n",
       "      <td>2011</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>创造101</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>0.108465</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.279115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>10601</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>美食</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>2006</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>火锅</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>0.055641</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0.271307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>10240</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>2009</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>漫威</td>\n",
       "      <td>0.054233</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.267357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>10910</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>理学院</td>\n",
       "      <td>理学</td>\n",
       "      <td>物理学</td>\n",
       "      <td>动漫</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>2003</td>\n",
       "      <td>串串香</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>串串香</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.263661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>10217</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>给排水科学与工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>2000</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.263661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>10345</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>火锅</td>\n",
       "      <td>2005</td>\n",
       "      <td>寿司</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>串串香</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>0.108465</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.230853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>10802</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>影视</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>2002</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>0.108465</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.230853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>10157</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>摄影</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2004</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>0.108465</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.230853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10009</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>2010</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.108465</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.230853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>10158</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>2015</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>串串香</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.226856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>10425</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>串串香</td>\n",
       "      <td>2006</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>火锅</td>\n",
       "      <td>0.105851</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.222772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>10225</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2014</td>\n",
       "      <td>创造101</td>\n",
       "      <td>档案</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>0.105851</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.222772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>10045</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>财务管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>创造101</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>2005</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>0.055641</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.222117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>10202</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>给排水科学与工程</td>\n",
       "      <td>美食</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>2017</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.055641</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0.222117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>10141</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>建筑学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>2011</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>0.054233</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.217692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>10768</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>建筑学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>2017</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.103418</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.215111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>10741</td>\n",
       "      <td>四川</td>\n",
       "      <td>广安市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>综艺</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>2015</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>0.055641</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.166637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>10113</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械设计与制造</td>\n",
       "      <td>综艺</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>2012</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>寿司</td>\n",
       "      <td>寿司</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>0.052926</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.156884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>10796</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>动漫</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>2007</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>档案</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.146128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>10807</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2001</td>\n",
       "      <td>创造101</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>创造101</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.109239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>10245</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>会计</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>串串香</td>\n",
       "      <td>2002</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>串串香</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>0.054233</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.097185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>10865</td>\n",
       "      <td>四川</td>\n",
       "      <td>巴中市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>2013</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.055641</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.028448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>10429</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>综艺</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>2016</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.054233</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.021516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956</th>\n",
       "      <td>10956</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>美食</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>2000</td>\n",
       "      <td>寿司</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.221849</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id region_parent region_detail school_parent school_detail  \\\n",
       "154  10154            四川           成都市          西华大学          经济学院   \n",
       "213  10213            四川           内江市        西南财经大学          经济学院   \n",
       "36   10036            四川           泸州市        西南石油大学          经济学院   \n",
       "674  10674            四川           内江市          西华大学          经济学院   \n",
       "386  10386            四川          攀枝花市        四川师范大学          建筑学院   \n",
       "713  10713            四川           雅安市      成都信息工程大学          经济学院   \n",
       "785  10785            四川           德阳市        西南石油大学          经济学院   \n",
       "655  10655            四川           成都市      成都信息工程大学          经济学院   \n",
       "843  10843            四川           资阳市          西华大学          管理学院   \n",
       "829  10829            四川           成都市          西华大学          经济学院   \n",
       "647  10647            四川           自贡市        西南交通大学          经济学院   \n",
       "614  10614            四川           泸州市        西南石油大学     土木与环境工程学院   \n",
       "744  10744            四川          攀枝花市        西南财经大学          管理学院   \n",
       "985  10985            四川           成都市        成都理工大学          经济学院   \n",
       "274  10274            四川           广元市        西南石油大学          经济学院   \n",
       "460  10460            四川           南充市      四川大学锦城学院          经济学院   \n",
       "974  10974            四川           广元市        电子科技大学       文学与传媒学院   \n",
       "346  10346            四川           成都市        西南石油大学          经济学院   \n",
       "665  10665            四川           成都市        西南石油大学       文学与传媒学院   \n",
       "576  10576            四川           德阳市        电子科技大学          经济学院   \n",
       "895  10895            四川           雅安市          西华大学          经济学院   \n",
       "445  10445            四川           成都市        西南石油大学          管理学院   \n",
       "789  10789            四川           泸州市          西华大学          电气学院   \n",
       "224  10224            四川           宜宾市        成都理工大学          艺术学院   \n",
       "207  10207            四川           成都市        西南财经大学         计算机学院   \n",
       "545  10545            四川           成都市      四川大学锦城学院          经济学院   \n",
       "700  10700            四川           宜宾市        四川师范大学          经济学院   \n",
       "992  10992            四川           自贡市      成都信息工程大学       文学与传媒学院   \n",
       "958  10958            四川           达州市        西南石油大学          管理学院   \n",
       "117  10117            四川           德阳市        西南石油大学          机械学院   \n",
       "..     ...           ...           ...           ...           ...   \n",
       "939  10939            四川           内江市          四川大学          管理学院   \n",
       "212  10212            四川          攀枝花市        西南石油大学          管理学院   \n",
       "542  10542            重庆            重庆      四川大学锦城学院          机械学院   \n",
       "20   10020            四川           广元市        电子科技大学          管理学院   \n",
       "551  10551            重庆            重庆      成都信息工程大学         计算机学院   \n",
       "517  10517            重庆            重庆        西南石油大学          管理学院   \n",
       "693  10693            四川           成都市      成都信息工程大学     土木与环境工程学院   \n",
       "601  10601            重庆            重庆        西南石油大学          管理学院   \n",
       "240  10240            重庆            重庆        西南石油大学          管理学院   \n",
       "910  10910            四川           自贡市        西南交通大学           理学院   \n",
       "217  10217            重庆            重庆          四川大学     土木与环境工程学院   \n",
       "345  10345            四川           自贡市        西南财经大学     土木与环境工程学院   \n",
       "802  10802            四川           乐山市        西南交通大学         计算机学院   \n",
       "157  10157            四川           宜宾市        成都理工大学          管理学院   \n",
       "9    10009            四川           眉山市        西南财经大学     土木与环境工程学院   \n",
       "158  10158            四川           德阳市        四川师范大学     土木与环境工程学院   \n",
       "425  10425            四川           眉山市        电子科技大学          管理学院   \n",
       "225  10225            四川           德阳市        四川师范大学          管理学院   \n",
       "45   10045            重庆            重庆        电子科技大学        财务会计学院   \n",
       "202  10202            重庆            重庆        西南石油大学     土木与环境工程学院   \n",
       "141  10141            四川           乐山市        西南交通大学          建筑学院   \n",
       "768  10768            四川           乐山市          四川大学          建筑学院   \n",
       "741  10741            四川           广安市      成都信息工程大学     土木与环境工程学院   \n",
       "113  10113            四川           泸州市        四川师范大学          机械学院   \n",
       "796  10796            重庆            重庆        西南石油大学          管理学院   \n",
       "807  10807            四川           自贡市        西南石油大学          管理学院   \n",
       "245  10245            四川           德阳市        西南石油大学        财务会计学院   \n",
       "865  10865            四川           巴中市        西南财经大学          管理学院   \n",
       "429  10429            重庆            重庆        西南交通大学          管理学院   \n",
       "956  10956            重庆            重庆        西南交通大学          管理学院   \n",
       "\n",
       "    major_parent major_detail interest_parent interest_detail  \\\n",
       "154          经济学          经济学              影视            美丽人生   \n",
       "213          经济学          经济学              技能              编程   \n",
       "36           经济学         电子商务              影视            阿甘正传   \n",
       "674          经济学         电子商务              名人             冯小刚   \n",
       "386           工学          建筑学              名人         迈克尔·杰克逊   \n",
       "713          经济学      国际经济与贸易              综艺           演员的诞生   \n",
       "785          经济学          金融学              名人            GALA   \n",
       "655          经济学          金融学              影视           泰坦尼克号   \n",
       "843          管理学         人力资源              影视            霸王别姬   \n",
       "829          经济学          经济学              综艺           演员的诞生   \n",
       "647          经济学          金融学              名人         迈克尔·杰克逊   \n",
       "614           工学         土木工程              动漫           妖精的尾巴   \n",
       "744          管理学         人力资源              动漫             七龙珠   \n",
       "985          经济学          经济学              名人            迪丽热巴   \n",
       "274          经济学          经济学              名人             冯小刚   \n",
       "460          经济学          经济学              技能              编程   \n",
       "974           文学         行政管理              影视             终结者   \n",
       "346          经济学          投资学              影视            让子弹飞   \n",
       "665           文学        汉语言文学              综艺           老梁故事汇   \n",
       "576          经济学         电子商务              动漫             七龙珠   \n",
       "895          经济学          经济学              综艺           真正男子汉   \n",
       "445          管理学         市场营销              技能              绘画   \n",
       "789           工学         电气工程              美食            糖醋排骨   \n",
       "224          艺术学         播音主持              名人             赵丽颖   \n",
       "207           工学         软件工程              动漫             七龙珠   \n",
       "545          经济学      国际经济与贸易              动漫            灌篮高手   \n",
       "700          经济学          经济学              影视           寻梦幻游记   \n",
       "992           文学         行政管理              名人             宋冬野   \n",
       "958          管理学         市场营销              动漫             七龙珠   \n",
       "117           工学      测控技术与仪器              综艺           创造101   \n",
       "..           ...          ...             ...             ...   \n",
       "939          管理学         工商管理              综艺           老梁故事汇   \n",
       "212          管理学         工商管理              动漫              死神   \n",
       "542           工学       机械电子工程              动漫              死神   \n",
       "20           管理学         市场营销              美食              火锅   \n",
       "551           工学         软件工程              综艺           真正男子汉   \n",
       "517          管理学         市场营销              综艺           老梁故事汇   \n",
       "693           工学       建筑工程技术              综艺           热血街舞团   \n",
       "601          管理学         工商管理              美食             卤肉饭   \n",
       "240          管理学         市场营销              动漫             海贼王   \n",
       "910           理学          物理学              动漫          中国惊奇先生   \n",
       "217           工学     给排水科学与工程              动漫             海贼王   \n",
       "345           工学       建筑工程技术              美食             牛肉面   \n",
       "802           工学         软件工程              影视            阿甘正传   \n",
       "157          管理学         市场营销              技能              摄影   \n",
       "9             工学       建筑工程技术              影视           复仇者联盟   \n",
       "158           工学       建筑工程技术              美食             串串香   \n",
       "425          管理学         工商管理              综艺           老梁故事汇   \n",
       "225          管理学         市场营销              动漫             海贼王   \n",
       "45           管理学         财务管理              综艺           创造101   \n",
       "202           工学     给排水科学与工程              美食            糖醋排骨   \n",
       "141           工学          建筑学              综艺           中国式相亲   \n",
       "768           工学          建筑学              综艺            天天向上   \n",
       "741           工学         土木工程              综艺            极限挑张   \n",
       "113           工学      机械设计与制造              综艺         蒙面唱将猜猜猜   \n",
       "796          管理学         人力资源              动漫          中国惊奇先生   \n",
       "807          管理学         工商管理              动漫          中国惊奇先生   \n",
       "245          管理学           会计              动漫             海贼王   \n",
       "865          管理学         市场营销              美食             串串香   \n",
       "429          管理学         人力资源              综艺            笑傲江湖   \n",
       "956          管理学         工商管理              美食             酸菜鱼   \n",
       "\n",
       "    interest_parent1    ...    interest_detail2  year interest_detail3  \\\n",
       "154               技能    ...              辛普森的一家  2008           搞笑漫画日和   \n",
       "213               影视    ...                灌篮高手  2004               死神   \n",
       "36                美食    ...                  编程  2011               绘画   \n",
       "674               名人    ...             迈克尔·杰克逊  2010               林允   \n",
       "386               名人    ...              辛普森的一家  2003            妖精的尾巴   \n",
       "713               名人    ...                  摄影  2008               文案   \n",
       "785               影视    ...                电子音乐  2000             电子音乐   \n",
       "655               美食    ...                  策划  2008               写作   \n",
       "843               美食    ...                电子音乐  2015               编程   \n",
       "829               动漫    ...                  文案  2001               摄影   \n",
       "647               美食    ...              中国惊奇先生  2004               死神   \n",
       "614               影视    ...               妖精的尾巴  2007             灌篮高手   \n",
       "744               技能    ...               春娇与志明  2016             环太平洋   \n",
       "985               影视    ...                  绘画  2010               编程   \n",
       "274               综艺    ...                 海贼王  2006            妖精的尾巴   \n",
       "460               名人    ...                 冯小刚  2012             GALA   \n",
       "974               名人    ...                 七龙珠  2006             火影忍者   \n",
       "346               动漫    ...               中国好声音  2005            中国好声音   \n",
       "665               综艺    ...                阿甘正传  2004             美丽人生   \n",
       "576               影视    ...                 豆腐脑  2006              豆腐脑   \n",
       "895               综艺    ...                一代宗师  2001             阿甘正传   \n",
       "445               名人    ...                环太平洋  2001            缝纫机乐队   \n",
       "789               技能    ...                 海贼王  2014          喜羊羊和灰太狼   \n",
       "224               动漫    ...                  写作  2014               料理   \n",
       "207               影视    ...                  花艺  2002               策划   \n",
       "545               美食    ...                电子音乐  2004               设计   \n",
       "700               综艺    ...                  林允  2005              周杰伦   \n",
       "992               影视    ...                  绘画  2017               编程   \n",
       "958               名人    ...                  绘画  2012             电子音乐   \n",
       "117               影视    ...                  设计  2002               编程   \n",
       "..               ...    ...                 ...   ...              ...   \n",
       "939               美食    ...              中国惊奇先生  2006           中国惊奇先生   \n",
       "212               综艺    ...             蒙面唱将猜猜猜  2004            真正男子汉   \n",
       "542               美食    ...                 赵丽颖  2002               鹿晗   \n",
       "20                动漫    ...                  档案  2003             天天向上   \n",
       "551               美食    ...                  烤肉  2014               火锅   \n",
       "517               影视    ...                  绘画  2004               料理   \n",
       "693               动漫    ...                  档案  2011            演员的诞生   \n",
       "601               名人    ...                糖醋排骨  2006              牛肉面   \n",
       "240               动漫    ...               寻梦幻游记  2009              迪斯尼   \n",
       "910               综艺    ...                 豆腐脑  2003              串串香   \n",
       "217               技能    ...               我们十七岁  2000             极限挑张   \n",
       "345               名人    ...                  火锅  2005               寿司   \n",
       "802               美食    ...                鱼香肉丝  2002               烤肉   \n",
       "157               综艺    ...               中国好声音  2004             天天向上   \n",
       "9                 美食    ...                 酸菜鱼  2010             三汁焖锅   \n",
       "158               美食    ...                 卤肉饭  2015              酸菜鱼   \n",
       "425               名人    ...                 串串香  2006               烤肉   \n",
       "225               影视    ...               中国好声音  2014            创造101   \n",
       "45                美食    ...                 海豚湾  2005             霸王别姬   \n",
       "202               美食    ...               复仇者联盟  2017            泰坦尼克号   \n",
       "141               动漫    ...                  烤肉  2011              卤肉饭   \n",
       "768               动漫    ...               缝纫机乐队  2017              迪斯尼   \n",
       "741               美食    ...                麻婆豆腐  2015             糖醋排骨   \n",
       "113               动漫    ...                三汁焖锅  2012              豆腐脑   \n",
       "796               综艺    ...                 奔跑吧  2007            真正男子汉   \n",
       "807               动漫    ...               中国好声音  2001            创造101   \n",
       "245               动漫    ...                 串串香  2002              豆腐脑   \n",
       "865               综艺    ...                 钵钵鸡  2013              牛肉面   \n",
       "429               美食    ...               泰坦尼克号  2016             环太平洋   \n",
       "956               综艺    ...                糖醋排骨  2000               寿司   \n",
       "\n",
       "     interest_detail4 interest_detail5 interest_detail6 similarity value  \\\n",
       "154             妖精的尾巴              七龙珠           搞笑漫画日和   0.596559     4   \n",
       "213               七龙珠            命运石之门              海贼王   0.370479     8   \n",
       "36                 编程               绘画               文案   0.325396     9   \n",
       "674               冯小刚               杨幂          泰勒·斯威夫特   0.285831     9   \n",
       "386               七龙珠              七龙珠            妖精的尾巴   0.278207     9   \n",
       "713                文案               料理               编程   0.370479     3   \n",
       "785                绘画               编程               书法   0.370479     4   \n",
       "655                写作               设计               文案   0.317554     8   \n",
       "843                设计               设计               绘画   0.271163     9   \n",
       "829                花艺               绘画               书法   0.370479     2   \n",
       "647             妖精的尾巴              七龙珠               死神   0.317554     5   \n",
       "614               七龙珠           搞笑漫画日和            妖精的尾巴   0.278207     8   \n",
       "744                漫威             美丽人生              海豚湾   0.258544     9   \n",
       "985                摄影               策划               文案   0.423405     3   \n",
       "274              火影忍者             火影忍者            命运石之门   0.271163     7   \n",
       "460           迈克尔·杰克逊              冯小刚              冯小刚   0.352941     8   \n",
       "974             妖精的尾巴              七龙珠          喜羊羊和灰太狼   0.317554     7   \n",
       "346             真正男子汉            中国式相亲             笑傲江湖   0.317554     9   \n",
       "665               海豚湾            泰坦尼克号            复仇者联盟   0.264628     8   \n",
       "576               卤肉饭              口水鸡             糖醋排骨   0.264628     9   \n",
       "895             复仇者联盟              迪斯尼            复仇者联盟   0.278207     9   \n",
       "445                漫威             美丽人生             帕丁顿熊   0.310253     7   \n",
       "789               七龙珠            妖精的尾巴           中国惊奇先生   0.258544     8   \n",
       "224                文案               书法               编程   0.258544     7   \n",
       "207                写作               文案             电子音乐   0.258544     9   \n",
       "545                料理               绘画               书法   0.258544     8   \n",
       "700               吴亦凡              吴亦凡              赵丽颖   0.271163     8   \n",
       "992              电子音乐               料理               料理   0.370479     6   \n",
       "958              电子音乐               料理               写作   0.211702     9   \n",
       "117                设计             电子音乐               花艺   0.211702     9   \n",
       "..                ...              ...              ...        ...   ...   \n",
       "939           无头骑士异闻录          喜羊羊和灰太狼            命运石之门   0.052926     4   \n",
       "212              笑傲江湖             极限挑张            我们十七岁   0.052926     4   \n",
       "542              迪丽热巴              冯小刚               张瀚   0.052926     1   \n",
       "20              快乐大本营            我们十七岁            真正男子汉   0.051709     3   \n",
       "551              糖醋排骨               烤肉             麻婆豆腐   0.000000     3   \n",
       "517                摄影             电子音乐               料理   0.111283     1   \n",
       "693             演员的诞生            创造101             天天向上   0.108465     2   \n",
       "601                火锅             麻婆豆腐              口水鸡   0.055641     5   \n",
       "240              环太平洋             让子弹飞               漫威   0.054233     1   \n",
       "910               口水鸡              串串香              酸菜鱼   0.052926     1   \n",
       "217              笑傲江湖            热血街舞团             天天向上   0.052926     1   \n",
       "345              鱼香肉丝              串串香              牛肉面   0.108465     1   \n",
       "802              麻婆豆腐              口水鸡              豆腐脑   0.108465     1   \n",
       "157             快乐大本营          蒙面唱将猜猜猜            我们十七岁   0.108465     1   \n",
       "9                 口水鸡              豆腐脑             麻婆豆腐   0.108465     1   \n",
       "158               豆腐脑             麻婆豆腐              串串香   0.057166     3   \n",
       "425               口水鸡               烤肉               火锅   0.105851     1   \n",
       "225                档案             天天向上          蒙面唱将猜猜猜   0.105851     1   \n",
       "45                海豚湾            复仇者联盟             霸王别姬   0.055641     1   \n",
       "202               迪斯尼             一代宗师              海豚湾   0.055641     4   \n",
       "141               卤肉饭              酸菜鱼              酸菜鱼   0.054233     2   \n",
       "768              阿甘正传             环太平洋              海豚湾   0.103418     1   \n",
       "741               酸菜鱼              酸菜鱼              牛肉面   0.055641     3   \n",
       "113                寿司               寿司             鱼香肉丝   0.052926     2   \n",
       "796                档案             极限挑张             非诚勿扰   0.000000     3   \n",
       "807              非诚勿扰             非诚勿扰            创造101   0.057166     2   \n",
       "245               串串香             鱼香肉丝              牛肉面   0.054233     1   \n",
       "865               钵钵鸡              钵钵鸡             麻婆豆腐   0.055641     1   \n",
       "429             泰坦尼克号             一代宗师              海豚湾   0.054233     1   \n",
       "956               牛肉面             鱼香肉丝              口水鸡   0.000000     1   \n",
       "\n",
       "     connect     score  \n",
       "154        1  0.911621  \n",
       "213        9  0.894635  \n",
       "36         7  0.851549  \n",
       "674        9  0.846954  \n",
       "386        9  0.841265  \n",
       "713        9  0.835421  \n",
       "785        8  0.835421  \n",
       "655        7  0.833188  \n",
       "843        8  0.823080  \n",
       "829        9  0.822544  \n",
       "647        9  0.820244  \n",
       "614        8  0.815477  \n",
       "744        8  0.813082  \n",
       "985        4  0.811633  \n",
       "274        9  0.809826  \n",
       "460        3  0.808568  \n",
       "974        6  0.806902  \n",
       "346        4  0.806902  \n",
       "665        8  0.804517  \n",
       "576        7  0.804517  \n",
       "895        6  0.801986  \n",
       "445        6  0.800925  \n",
       "789        8  0.799515  \n",
       "224        9  0.799515  \n",
       "207        7  0.799515  \n",
       "545        8  0.799515  \n",
       "700        7  0.796155  \n",
       "992        3  0.795585  \n",
       "958        9  0.788199  \n",
       "117        9  0.788199  \n",
       "..       ...       ...  \n",
       "939        3  0.308587  \n",
       "212        3  0.308587  \n",
       "542        6  0.308587  \n",
       "20         4  0.305460  \n",
       "551        7  0.301030  \n",
       "517        2  0.286770  \n",
       "693        1  0.279115  \n",
       "601        1  0.271307  \n",
       "240        5  0.267357  \n",
       "910        5  0.263661  \n",
       "217        5  0.263661  \n",
       "345        1  0.230853  \n",
       "802        1  0.230853  \n",
       "157        1  0.230853  \n",
       "9          1  0.230853  \n",
       "158        2  0.226856  \n",
       "425        1  0.222772  \n",
       "225        1  0.222772  \n",
       "45         4  0.222117  \n",
       "202        1  0.222117  \n",
       "141        3  0.217692  \n",
       "768        1  0.215111  \n",
       "741        1  0.166637  \n",
       "113        2  0.156884  \n",
       "796        4  0.146128  \n",
       "807        1  0.109239  \n",
       "245        2  0.097185  \n",
       "865        1  0.028448  \n",
       "429        1  0.021516  \n",
       "956        2 -0.221849  \n",
       "\n",
       "[1000 rows x 22 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data.sort_values('score',ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "可以看出id为10154的用户和10213的用户、10036的用户推荐系数更高  \n",
    "10154的用户在相似度上与模拟用户更加接近，达到了0.596559，所以加权相加后，推荐系数为0.911621  \n",
    "10213的用户和10036的用户在用户价值和用户联系系数上更高，分别是8、9，推荐系数分别为0.894635、0.851549  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "set(user_data.loc[5,:])&set(user_data.loc[788,:])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
